﻿
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[usp_HeadYarns_Tbl_Ins] 
	@YarnType nvarchar(50),
	@CMMperDPI float,
	@PrimYarnTypeID int,
	@SecYarnTypeID int,
	@Europerkg int,
	@MaxDPIID int,
	@GenericYarnID int
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

INSERT INTO HeadYarns_Tbl (YarnType, CMMperDPI, PrimYarnTypeID, SecYarnTypeID, Europerkg, MaxDPIID, GenericYarnID) VALUES (@YarnType, @CMMperDPI, @PrimYarnTypeID, @SecYarnTypeID, @Europerkg, @MaxDPIID, @GenericYarnID)
END